{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Table Design Before","Table Design After","Number Formatting","Get Color Codes"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Table Design Before","index":0,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,3,1,4],[1,5,1,6],[1,7,1,8]]}
[null,"Top 10 Domestic Routes by Revenue"]
[null,null,null,"Revenue",null,"Margin",null,"Per Passenger"]
[null,"From","To","Revenue Dollars","Revenue Percent","Margin Dollars","Margin Percent","Revenue per Passenger","Margin  per Passenger"]
[null,"Atlanta ","New York",3602000,{"$f":"D4/$D$14","v":8.0882022724210717E-2},955000,{"$f":"F4/$F$14","v":9.0128350320875808E-2},245,65]
[null,"Chicago ","New York",4674000,0.1049535186599003,336000,3.1710079275198186E-2,222,16]
[null,"Columbus (Ohio) ","New York",2483000,5.5755153365967577E-2,1536000,0.14496036240090601,202,125]
[null,"New York ","Detroit",12180000,0.27349889971707009,2408000,0.22725556813892034,177,35]
[null,"New York ","Washington",6355000,0.14269995958144338,1230000,0.1160815402038505,186,36]
[null,"New York ","Philadelphia",3582000,8.0432927650783664E-2,-716000,-6.7572668931672325E-2,125,-25]
[null,"New York ","San Francisco",3221000,7.2326761575425516E-2,1856000,0.17516043790109476,590,340]
[null,"New York ","Phoenix",2846000,6.3906228948668431E-2,1436000,0.13552283880709701,555,280,null,null,null,null," "]
[null,"New York ","Toronto",2799000,6.2850855526114885E-2,1088000,0.10268025670064175,450,175]
[null,"New York ","Seattle",2792000,6.2693672250415416E-2,467000,4.4073235183087957E-2,448.42207883211677,75]
[null,"Total Domestic routes",null,{"$f":"SUM(D4:D13)","v":44534000},null,{"$f":"SUM(F4:F13)","v":10596000},null,271.72236927122623,52.52599274261717]

{"sheet":"Table Design After","index":1,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,7,1,8],[1,3,1,4],[1,5,1,6]]}
[null,"Top 10 Domestic Routes by Revenue"]
[null,null,null,"Revenue",null,"Margin",null,"Per Passenger"]
[null,"From","To","Revenue\n$ (000's)","Revenue\n%","Margin\n$ (000's)","Margin\n%","$ per Passenger","Margin  $\nper Passenger"]
[null,"New York ","Detroit",12180000,{"$f":"D4/$D$14","v":0.27349889971707009},2408000,{"$f":"F4/$F$14","v":0.22725556813892034},177,35]
[null,"New York ","Washington",6355000,0.14269995958144338,1230000,0.1160815402038505,186,36]
[null,"Chicago ","New York",4674000,0.1049535186599003,336000,3.1710079275198186E-2,222,16]
[null,"Atlanta ","New York",3602000,8.0882022724210717E-2,955000,9.0128350320875808E-2,245,65]
[null,"New York ","Philadelphia",3582000,8.0432927650783664E-2,-716000,-6.7572668931672325E-2,125,-25]
[null,"New York ","San Francisco",3221000,7.2326761575425516E-2,1856000,0.17516043790109476,590,340]
[null,"New York ","Phoenix",2846000,6.3906228948668431E-2,1436000,0.13552283880709701,555,280]
[null,"New York ","Toronto",2799000,6.2850855526114885E-2,1088000,0.10268025670064175,450,175,null,null,null,null," "]
[null,"New York ","Seattle",2792000,6.2693672250415416E-2,467000,4.4073235183087957E-2,448.42207883211677,75]
[null,"Columbus (Ohio) ","New York",2483000,5.5755153365967577E-2,1536000,0.14496036240090601,202,125]
[null,"Total Domestic routes",null,{"$f":"SUM(D4:D13)","v":44534000},null,{"$f":"SUM(F4:F13)","v":10596000},null,271.72236927122623,52.52599274261717]

{"sheet":"Number Formatting","index":2,"n_rows":71,"n_cols":6,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Formatting Large Numbers"]
[null,null,"January","February","March"]
[null,"North",117943.60578700402,380439.21576375351,462846.08073880128,{"$f":"SUM(C6:E6)","v":961228.90228955878}]
[null,"Northeast",24304.53443570757,802648.42567966401,327504.5375963985,1154457.4977117702]
[null,"East",313415.70027856267,779825.60647898749,904132.33973732626,1997373.6464948766]
[null,"Southeast",397459.21065891429,466308.9009030523,831589.07524858019,1695357.1868105468]
[null,"South",839626.35878236778,117786.13518216119,800466.20991392748,1757878.7038784565]
[null,"Southwest",622572.23449242779,976698.81478578469,807868.28671820567,2407139.3359964183]
[null,"West",474499.15037473734,78914.154736285273,876094.8015246077,1429508.1066356304]
[null,"Northwest",840582.68213645346,101804.602845748,615611.24312289013,1557998.5281050915]
[null,"Totals",{"$f":"SUM(C6:C13)","v":3630403.4769461751},{"$f":"SUM(D6:D13)","v":3704425.8563754363},{"$f":"SUM(E6:E13)","v":5626112.5746007375},12960941.90792235]
[]
[]
[]
[]
[null,"Understanding Postive and Negative Formatting"]
[null,-1890]
[null,-525]
[null,1982]
[null,2744]
[null,526]
[null,7419]
[]
[]
[]
[]
[null,"Better Formatting for Percentages"]
["North",0.47]
["South",0.5]
["East ",-0.23]
["West",-0.43]
[]
[]
[]
[]
[null,"Suppressing Zeros"]
[null,null,"Jim","Tim","Kim"]
[null,"Printers",37000,64000,24000]
[null,"Copiers",18000,29000,58000]
[null,"Scanners",0,77000,88000]
[null,"Service Contracts",16000,12000,0]
[null,"Warranties",65000,88000,16000]
[]
[]
[]
[]
[]
[]
[]
[null,"Adding your own Custom Format Criteria"]
[null,733]
[null,309]
[null,281]
[null,790]
[null,709]
[null,500]
[null,624]
[null,341]
[]
[]
[]
[null,"Formatting Dates and Times"]
[null,"2013-01-01"]
[null,"2013-02-01"]
[null,"2013-03-01"]
[null,"2013-04-01"]
[null,41305.819435185185]
[null,"2013-01-31T19:42:53"]

{"sheet":"Get Color Codes","index":3,"n_rows":56,"n_cols":2,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]
[null,51]
[null,52]
[null,53]
[null,54]
[null,55]
[null,56]